package com.example.attempt.mapper;

import com.example.attempt.entity.Assessment;
import com.example.attempt.entity.Evaluation;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface AssessmentMapper {
    public List<Assessment> queryAll();
    public List<Assessment> queryBySid(String sid);
    public List<Assessment> queryByTid(String tid);
    public Assessment getAsseByHidSid(int hid, String sid);
    public List<Evaluation> getAsseBySid(String sid, int hid); //查找某学生应该评价的提交作业号
    public List<Evaluation> getAsseByTid(String tid, int hid); //查找某老师应该评价的提交作业号
    public List<Evaluation> getAsseByAid(String aid, int hid);
    public int addAsse(Assessment asse);
    public int deleteAsse(int submitId);
    public Assessment selectBySid1(int submitId, String sid);
    public Assessment selectBySid2(int submitId, String sid);
    public Assessment selectBySid3(int submitId, String sid);
    public int updateS1comment(int submitId, String comment);
    public int updateS2comment(int submitId, String comment);
    public int updateS3comment(int submitId, String comment);
    public int updateTcomment(int submitId, String comment);
    public int updateAcomment(int submitId, String comment);
    public int updateAsse(Assessment asse);
}
